﻿

CREATE FUNCTION [dbo].[GL_Input]
(	@ApplID int
)RETURNS TABLE AS
RETURN ( 
SELECT
LoanID,
DealerID,
StatusID,
ContractHolderID,
SalesPrice,
AF_Adjusted,
Overage_AF,
Overage_SP,
BookValue,
BookValueDesc,
ModelAge,
Mileage,
MilesPerYear,
DownPayment,
DownPaymentRatio,
GAP,
ServiceContract,
LoanTerm,
IsSUV,
TrackerTypeID,
AmountFinanced,
APR,
Payment,
AddOnRateByPayment,
IsIndependent,
JobTimeCurrent,
MonthsCurrent ResidenceTime,
DTI,
PTI,
GrossIncome
FROM v_PurchaseContract
WHERE (LoanID = @ApplID)
)





